home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 8 / developer source - volume 8.iso / orinf / jan96 / kolsf105.gif < prev    next >
Graphics Interchange Format  |  1996-11-16  |  13.7 KB  |  784x408  |  4-bit (9 colors)
   ocr: Oracle Power Objects File Edit Database Window Help STOP Report Generator 44 Enter the Sgl Statement create view OrdTot (repid, country, CO id, ord_tot) as 1 Enter SQL select emp.empno repid, countries.name country, cour sumunit.pricesquanttyw(-dliscount) ord_totfrom Execute SQL emp, orders, order_ items, countries, products where empno-sales rep_id and orders.id-order id an country_id-countries